﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ZhimeiSoft.Framework.Common.TableInfo
{
    /// <summary>
    /// 员工信息表
    /// </summary>
    public class DBEmployeeInfo : DBBaseInfo
    {
        /// <summary>
        /// 表名称
        /// </summary>
        /// <returns>返回表名称</returns>
        public override string GetTableName()
        {
            return "EMPLOYEEINFO";
        }
        /// <summary>
        /// 主记录
        /// </summary>
        public int EMPLOYEEID { get; set; }
        /// <summary>
        /// 姓名
        /// </summary>
        public string ENAME { get; set; }
        /// <summary>
        /// 代码
        /// </summary>
        public string ECODE { get; set; }
        /// <summary>
        /// 身份证号码
        /// </summary>
        public string ECARD { get; set; }
        /// <summary>
        /// 生日
        /// </summary>
        public DateTime EBIRTHDAY { get; set; }
        /// <summary>
        /// 住址
        /// </summary>
        public string EADDRESS { get; set; }
        /// <summary>
        /// 移动电话
        /// </summary>
        public string EMOBILEPHONE { get; set; }
        /// <summary>
        /// 家庭电话
        /// </summary>
        public string EFAMLIYPHONE { get; set; }
        /// <summary>
        /// 学历
        /// </summary>
        public string EDUCATION { get; set; }
        /// <summary>
        /// 入职日期
        /// </summary>
        public DateTime ENTRYDAY { get; set; }
        /// <summary>
        /// 离职日期
        /// </summary>
        public DateTime EQUITDAY { get; set; }
        /// <summary>
        /// F0E 在职、 F0Q 离职、 F0S停岗
        /// </summary>
        public string ESTATE { get; set; }
        /// <summary>
        /// 快速定位码
        /// </summary>
        public string EINDEXCODE { get; set; }
        /// <summary>
        /// 属于哪个店
        /// </summary>
        public int SALONID { get; set; }

        /// <summary>
        /// C0A 有效会员 C0I 注销会员 C0L 长时间不到店
        /// </summary>
        public static class ENUM_ESTATE
        {
            /// <summary>
            ///  F0E 在职
            /// </summary>
            public const string F0E = "F0E";
            /// <summary>
            ///   F0Q 离职
            /// </summary>
            public const string F0Q = "F0Q";
            /// <summary>
            ///  F0S停岗
            /// </summary>
            public const string F0S = "F0S";
        }
        /// <summary>
        /// 字段名
        /// </summary>
        public static class FieldName
        {
            /// <summary>
            /// 主记录
            /// </summary>
            public const string EMPLOYEEID = "EMPLOYEEID";
            /// <summary>
            /// 姓名
            /// </summary>
            public const string ENAME = "ENAME";
            /// <summary>
            /// 代码
            /// </summary>
            public const string ECODE = "ECODE";
            /// <summary>
            /// 身份证号码
            /// </summary>
            public const string ECARD = "ECARD";
            /// <summary>
            /// 生日
            /// </summary>
            public const string EBIRTHDAY = "EBIRTHDAY";
            /// <summary>
            /// 住址
            /// </summary>
            public const string EADDRESS = "EADDRESS";
            /// <summary>
            /// 移动电话
            /// </summary>
            public const string EMOBILEPHONE = "EMOBILEPHONE";
            /// <summary>
            /// 家庭电话
            /// </summary>
            public const string EFAMLIYPHONE = "EFAMLIYPHONE";
            /// <summary>
            /// 学历
            /// </summary>
            public const string EDUCATION = "EDUCATION";
            /// <summary>
            /// 入职日期
            /// </summary>
            public const string ENTRYDAY = "ENTRYDAY";
            /// <summary>
            /// 离职日期
            /// </summary>
            public const string EQUITDAY = "EQUITDAY";
            /// <summary>
            /// F0E 在职、 F0Q 离职、 F0S停岗
            /// </summary>
            public const string ESTATE = "ESTATE";
            /// <summary>
            /// 快速定位码
            /// </summary>
            public const string EINDEXCODE = "EINDEXCODE";
            /// <summary>
            /// 属于哪个店
            /// </summary>
            public const string SALONID = "SALONID";
        }
    }
}
